use RD_DWCR;
select Count (*) from [JDEGAAccountLedger]
Where 
[GLDate]>= Convert (datetime, '07-01-2009 00:00:00', 120)
 ---39,250,316 records

use RD_DWCR;

select count(*) from dbo.JDEINItemLedger
where
[GLDate]>= Convert (datetime, '07-01-2009 00:00:00', 120)

-- 23,172,579 records as of 7/23/2010 